package com.woniu.mapper;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.woniu.pojo.InspectorFeedback;
import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.baomidou.mybatisplus.core.metadata.IPage;
import com.woniu.entity.dto.QueryInspectorFeedBackDTO;
import com.woniu.entity.vo.InspectroFeedBackVo;
import com.woniu.pojo.Inspector;
import com.woniu.pojo.InspectorFeedback;
import org.apache.ibatis.annotations.Select;

/**
* @author Ma.Lei
* @description 针对表【t_inspector_feedback】的数据库操作Mapper
* @createDate 2022-12-16 23:27:55
* @Entity generator.domain.InspectorFeedback
*/
public interface InspectorFeedbackMapper extends BaseMapper<InspectorFeedback> {

    @Select("select ti.`inspector_name`,ti.`inspector_phone` from t_inspector as ti inner join t_inspector_feedback as tif on ti.id = tif.inspector_id where tif.inspector_id=#{id}")
    Inspector getByInspector(String id);


    IPage<InspectroFeedBackVo> selectPageIns(IPage<InspectroFeedBackVo> page, QueryInspectorFeedBackDTO queryInspectorFeedBackDTO);
}




